{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Collateral Tables","Note Balances","Cumulative Defaults"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":9,"defined_names":24,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Collateral Tables","index":0,"n_rows":248,"n_cols":15,"rows_kept":248,"cut":false,"hidden":false,"merged":[]}
[null,"CNH CAPITAL AUSTRALIA RECEIVABLES TRUST SERIES 2013-1 (TERM DEAL)"]
[null,"COLLATERAL DATA TABLES"]
[]
[null,"OUTSTANDING RECEIVABLES",null,null,"2014-03-31",null,null,null,"2013-12-31",null,null,null,"2013-09-30"]
[]
[null,"Opening Balance",null,null,{"$f":"I13","v":343183216.40999991},null,null,null,367572501.20999992,null,null,null,399999996.31]
[null,"Principal Repayments - Scheduled",null,null,{"$f":"[4]Sheet1!$B$2+[5]Sheet1!$B$2+[6]Sheet1!$B$2","v":62541048.239999987},null,null,null,19784632.49000001,null,null,null,28316894.299999997]
[null,"Principal Repayments - Unscheduled",null,null,{"$f":"MAX('[3]16 Apr 14'!$H23-'Collateral Tables'!E7,0)","v":2187328.1800000817},null,null,null,4506158.3999999613,null,null,null,3783540.9800000787]
[{"$f":"SUM(M9,I9,E9)","v":1412940.09},"Charge-Offs",null,null,{"$f":"'[3]16 Apr 14'!$H37","v":987386.3600000001},null,null,null,98493.91,null,null,null,327059.82]
[null,"Reinstatements"]
[null,"New Receivables Purchased"]
[null,"Non Cash Change in Receivables"]
[null,"Closing Balance",null,null,{"$f":"E6-E7-E8-E9+E10+E11-E12","v":277467453.62999982},null,null,null,343183216.40999991,null,null,null,367572501.20999992]
[]
[null,"PORTFOLIO STATISTICS"]
[]
[null,"Summary"]
[null,"Number of contracts",null,null,{"$f":"'[7]Servicer Recon'!$B$4","v":4163},null,null,null,4387,null,null,null,4617]
[null,"Dollar value of contracts",null,null,{"$f":"'[7]Servicer Recon'!$B$5","v":277467453.63000029},null,null,null,343183216.41000015,null,null,null,367572501.21000028]
[null,"Number of contracts closed during the Quarter",null,null,{"$f":"'[7]Servicer Recon'!$B$19","v":221},null,null,null,228,null,null,null,183]
[null,"Dollar value of contracts closed during the Quarter",null,null,{"$f":"'[7]Servicer Recon'!$B$20","v":10700990.200000003},null,null,null,9069702.0300000031,null,null,null,8446613.110000005]
[]
[{"$f":"SUM(M23,I23,E23)","v":113967.13363636364},"Dollar Value of Recoveries from Collateral",null,null,{"$f":"MAX('[7]Servicer Recon'!$C$16,0)","v":19020.849999999999},null,null,null,94500,null,null,null,446.28363636364156]
[null,"Dollar Value of Recoveries from Other Sources",null,null,0,null,null,null,0,null,null,null,0]
[]
[null,"Average Term of Contracts (Months)",null,null,{"$f":"'[8]Revised Base Table'!$W$4167","v":52.232977773264125},null,null,null,51.719252312429639,null,null,null,51.33729628389451]
[null,"Average Term to Maturity (Months)",null,null,{"$f":"'[8]Revised Base Table'!$X$4167","v":29.553464471601743},null,null,null,31.625494308828717,null,null,null,33.937634820954983]
[null,"Average Residual / Balloon Payment *",null,null,{"$f":"'[8]Revised Base Table'!$AI$4167","v":2.9672797460436096E-2},null,null,null,2.8756254370488909E-2,null,null,null,3.0683073715412873E-2]
[null,"Average Seasoning (Months)",null,null,{"$f":"E26-E27","v":22.679513301662382},null,null,null,20.093758003600922,null,null,null,17.399661462939527]
[null,"Average Dollar Value of Individual Assets",null,null,{"$f":"E19/E18","v":66650.841611818469},null,null,null,78227.311695919794,null,null,null,79612.844100065035]
[null,"Weighted Average Interest Rate",null,null,{"$f":"'[8]Revised Base Table'!$AA$4167","v":5.649380812347129},null,null,null,5.6768052315365471,null,null,null,5.7023006689852697E-2]
[]
[null,"Payment in Arrears"]
["1. 0 - 30 Days","0 - 30 Days",null,null,{"$f":"IFERROR(VLOOKUP($A34,[9]Arrears!$A:$D,3,FALSE),0)","v":4144},{"$f":"IFERROR(VLOOKUP($A34,[9]Arrears!$A:$D,2,FALSE),0)","v":1000907.0400000002},{"$f":"F34/F$50","v":3.6072952950175503E-3},null,4375,439735.71,1.2813438681530656E-3,null,4592,151245.59999999998,4.1147147706131298E-4]
["2. 31 - 60 Days","31 - 60 Days",null,null,{"$f":"IFERROR(VLOOKUP($A35,[9]Arrears!$A:$D,3,FALSE),0)","v":14},{"$f":"IFERROR(VLOOKUP($A35,[9]Arrears!$A:$D,2,FALSE),0)","v":244533.99000000008},{"$f":"F35/F$50","v":8.8130693096021072E-4},null,7,47270.050000000017,1.3773998185134619E-4,null,12,113514.01999999996,3.0882076223419006E-4]
["3. 61 - 90 Days","61 - 90 Days",null,null,{"$f":"IFERROR(VLOOKUP($A36,[9]Arrears!$A:$D,3,FALSE),0)","v":3},{"$f":"IFERROR(VLOOKUP($A36,[9]Arrears!$A:$D,2,FALSE),0)","v":32291.389999999992},1.163790187913722E-4,null,5,79546.5,2.3179018144338975E-4,null,6,75092.269999999975,2.0429240422721002E-4]
["4. 91 - 120 Days","91 - 120 Days",null,null,{"$f":"IFERROR(VLOOKUP($A37,[9]Arrears!$A:$D,3,FALSE),0)","v":1},{"$f":"IFERROR(VLOOKUP($A37,[9]Arrears!$A:$D,2,FALSE),0)","v":8490.2099999999991},3.0598940124060822E-5,null,0,0,0,null,4,69228.5,1.8833971467427225E-4]
["5. 121 - 150 Days","121 - 150 Days",null,null,{"$f":"IFERROR(VLOOKUP($A38,[9]Arrears!$A:$D,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A38,[9]Arrears!$A:$D,2,FALSE),0)","v":0},0,null,0,0,0,null,3,96751.01999999999,2.6321615376968745E-4]
["6. 151 - 180 Days","151 - 180 Days",null,null,{"$f":"IFERROR(VLOOKUP($A39,[9]Arrears!$A:$D,3,FALSE),0)","v":1},{"$f":"IFERROR(VLOOKUP($A39,[9]Arrears!$A:$D,2,FALSE),0)","v":35526.209999999977},1.2803739514391402E-4,null,0,0,0,null,0,0,0]
[null,"Total",null,null,{"$f":"SUM(E34:E39)","v":4163},{"$f":"SUM(F34:F39)","v":1321748.8400000001},{"$f":"SUM(G34:G39)","v":4.7636175800371081E-3},null,4387,566552.26,1.6508740314478015E-3,null,4617,505831.40999999992,1.3761405119666727E-3]
[null,"* Expressed as a % of Aggreg. Rec. closing bal.",null,null,null,"> 30 days",{"$f":"SUM(G35:G39)","v":1.1563222850195576E-3},null,null,"> 30 days",3.6953016329473594E-4,null,null,"> 30 days",9.6466903490535977E-4]
[]
[" 0 - 30 Days","Account Balances in Arrears"]
["1. 0 - 30 Days","0 - 30 Days",null,null,{"$f":"IFERROR(VLOOKUP($A44,[9]Arrears!$A:$D,3,FALSE),0)","v":4144},{"$f":"IFERROR(VLOOKUP($A44,[9]Arrears!$A:$D,4,FALSE),0)","v":276040244.91000026},{"$f":"F44/F$50","v":0.99485630223895327},null,4375,342575641.11000001,0.99822958912048265,null,4592,366297114.92000002,0.99653024563643466]
["2. 31 - 60 Days","31 - 60 Days",null,null,{"$f":"IFERROR(VLOOKUP($A45,[9]Arrears!$A:$D,3,FALSE),0)","v":14},{"$f":"IFERROR(VLOOKUP($A45,[9]Arrears!$A:$D,4,FALSE),0)","v":805069.69},{"$f":"F45/F$50","v":2.9014923352904355E-3},null,7,207562.01,6.0481398878209195E-4,null,12,447641.17,1.2178309545094492E-3]
["3. 61 - 90 Days","61 - 90 Days",null,null,{"$f":"IFERROR(VLOOKUP($A46,[9]Arrears!$A:$D,3,FALSE),0)","v":3},{"$f":"IFERROR(VLOOKUP($A46,[9]Arrears!$A:$D,4,FALSE),0)","v":415013.80000000005},1.4957206496492967E-3,null,5,400013.29000000004,1.1655968907351964E-3,null,6,318477.56,8.6643467330013539E-4]
["4. 91 - 120 Days","91 - 120 Days",null,null,{"$f":"IFERROR(VLOOKUP($A47,[9]Arrears!$A:$D,3,FALSE),0)","v":1},{"$f":"IFERROR(VLOOKUP($A47,[9]Arrears!$A:$D,4,FALSE),0)","v":174400.78},6.285449976866891E-4,null,0,0,0,null,4,167153.97,4.547510204102626E-4]
["5. 121 - 150 Days","121 - 150 Days",null,null,{"$f":"IFERROR(VLOOKUP($A48,[9]Arrears!$A:$D,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($A48,[9]Arrears!$A:$D,4,FALSE),0)","v":0},0,null,0,0,0,null,3,342113.59,9.3073771534542802E-4]
["6. 151 - 180 Days","151 - 180 Days",null,null,{"$f":"IFERROR(VLOOKUP($A49,[9]Arrears!$A:$D,3,FALSE),0)","v":1},{"$f":"IFERROR(VLOOKUP($A49,[9]Arrears!$A:$D,4,FALSE),0)","v":32724.449999999983},1.1793977842041853E-4,null,0,0,0,null,0,0,0]
[null,"Total",null,null,{"$f":"SUM(E44:E49)","v":4163},{"$f":"SUM(F44:F49)","v":277467453.63000023},{"$f":"SUM(G44:G49)","v":1.0000000000000002},null,4387,343183216.41000003,0.99999999999999989,null,4617,367572501.21000004,1]
["NSW",null,null,null,null,"> 30 days",{"$f":"SUM(G45:G49)","v":5.1436977610468402E-3},null,null,"> 30 days",1.7704108795172885E-3,null,null,"> 30 days",3.4697543635652753E-3]
[null,null,null,null,null,">90 days",{"$f":"SUM(G47:G49)","v":7.4648477610710768E-4},null,null,">90 days",0,null,null,">90 days",1.3854887357556906E-3]
[]
["VIC","Geographic Distribution"]
["NSW","New South Wales",null,null,{"$f":"F55/F$63","v":0.31785757427106126},{"$f":"IFERROR(VLOOKUP($A55,[9]Geographic!$A:$C,3,FALSE),0)","v":88195131.749999925},null,null,0.30462584249779701,104542476.42999999,null,null,0.30594728550096595,112457808.97]
["VIC","Victoria",null,null,0.17961117463692206,{"$f":"IFERROR(VLOOKUP($A56,[9]Geographic!$A:$C,3,FALSE),0)","v":49836255.269999981},null,null,0.17346335124640827,59529710.80999995,null,null,0.17560707835193193,64548333.020000048]
["QLD","Queensland",null,null,0.11696645839146819,{"$f":"IFERROR(VLOOKUP($A57,[9]Geographic!$A:$C,3,FALSE),0)","v":32454385.370000008},null,null,0.10914968331449117,37458339.389999971,null,null,0.11503991220997688,42285508.270000011]
["SA","South Australia",null,null,0.18971966942903601,{"$f":"IFERROR(VLOOKUP($A58,[9]Geographic!$A:$C,3,FALSE),0)","v":52641033.579999954},null,null,0.20273041431863192,69573675.649999991,null,null,0.19643661234807192,72204696.929999948]
["NT","Northern Territory",null,null,1.7710440398364222E-3,{"$f":"IFERROR(VLOOKUP($A59,[9]Geographic!$A:$C,3,FALSE),0)","v":491407.08000000013},null,null,1.6685589872084282E-3,572621.44000000018,null,null,1.6681469859185394E-3,613164.96000000008]
["ACT","Australian Capital Territory",null,null,8.2742562054195941E-4,{"$f":"IFERROR(VLOOKUP($A60,[9]Geographic!$A:$C,3,FALSE),0)","v":229583.68},null,null,7.7193157279436457E-4,264913.95999999996,null,null,8.1428923277641842E-4,299310.32999999996]
["TAS","Tasmania",null,null,1.1851378916624257E-2,{"$f":"IFERROR(VLOOKUP($A61,[9]Geographic!$A:$C,3,FALSE),0)","v":3288371.9299999992},null,null,1.0762703807715622E-2,3693579.3099999996,null,null,1.1006060019948898E-2,4045525.0099999984]
["WA","Western Australia",null,null,0.18139527469450978,{"$f":"IFERROR(VLOOKUP($A62,[9]Geographic!$A:$C,3,FALSE),0)","v":50331284.969999984},null,null,0.19682751425495335,67547899.419999987,null,null,0.19348061535040967,71118153.719999984]
[null,"Total",null,null,{"$f":"SUM(E55:E62)","v":0.99999999999999978},{"$f":"SUM(F55:F62)","v":277467453.62999988},null,null,1,343183216.40999985,null,null,1.0000000000000002,367572501.20999992]
["AG"]
["CE","Top Industry Distribution"]
["AGRICULTURAL MACHINERY","Agricultural",null,null,{"$f":"F66/F$69","v":0.97714670950757454},{"$f":"IFERROR(VLOOKUP($A66,'[9]Top Industry'!$A:$C,3,FALSE),)","v":271126409.31000036},null,null,0.97916386563188684,336032604.80000001,null,null,0.97644352275674418,358913787.94999999]
["CONSTRUCTION EQUIPMENT","Construction",null,null,{"$f":"F67/F$69","v":2.2853290492425495E-2},{"$f":"IFERROR(VLOOKUP($A67,'[9]Top Industry'!$A:$C,3,FALSE),)","v":6341044.3199999984},null,null,2.0836134368113105E-2,7150611.6099999985,null,null,2.3556477243255856E-2,8658713.2599999998]
["MOTOR VEHICLE - AG","Motor Vehicle AG",null,null,{"$f":"F68/F$69","v":0},{"$f":"IFERROR(VLOOKUP($A68,'[9]Top Industry'!$A:$C,3,FALSE),)","v":0},null,null,0,0,null,null,0,0]
[null,"Total",null,null,{"$f":"SUM(E66:E68)","v":1},{"$f":"SUM(F66:F68)","v":277467453.63000035},null,null,1,343183216.41000003,null,null,1,367572501.20999998]
["COMBINE"]
["40-100 HP TRACTOR","Collateral Types"]
["100<140 HP TRACTOR","100-140 HP TRACTOR",null,null,{"$f":"IFERROR(F72/F$108,0)","v":9.4558248135965278E-2},{"$f":"IFERROR(VLOOKUP($A72,[9]Collateral!$A:$C,3,FALSE),\"\")","v":26236836.330000002},null,null,{"$f":"J72/$J$108","v":8.7613314265574477E-2},30067418.989999987,null,null,8.9918451612853542E-2,33059288.450000003]
["4 EWD Tractors","4 EWD Tractors",null,null,0.12741599022688957,{"$f":"IFERROR(VLOOKUP($A73,[9]Collateral!$A:$C,3,FALSE),\"\")","v":35353790.360000044},null,null,{"$f":"J73/$J$108","v":0.12456718815446809},42749368.290000014,null,null,0.1233070393158724,45334888.530000031]
["40<100 HP Tractor","40<100 HP Tractor",null,null,{"$f":"IFERROR(F74/F$108,0)","v":0},{"$f":"IFERROR(VLOOKUP($A74,[9]Collateral!$A:$C,3,FALSE),\"\")","v":""},null,null,0,"",null,null,0,""]
["40<60 HP TRACTOR","40-60 HP TRACTOR",null,null,{"$f":"IFERROR(F75/F$108,0)","v":1.016631036576107E-2},{"$f":"IFERROR(VLOOKUP($A75,[9]Collateral!$A:$C,3,FALSE),\"\")","v":2820820.2500000005},null,null,9.5101854459596416E-3,3263736.0300000003,null,null,1.0298926695894554E-2,3786488.56]
["4WD VEHICLE","4WD VEHICLE",null,null,1.4758008358920752E-4,{"$f":"IFERROR(VLOOKUP($A76,[9]Collateral!$A:$C,3,FALSE),\"\")","v":40948.67},null,null,1.3383367193903851E-4,45929.47,null,null,1.2765896157056084E-4,46934.91]
["60<100 HP TRACTOR","60-100 HP TRACTOR",null,null,6.6170983190278115E-2,{"$f":"IFERROR(VLOOKUP($A77,[9]Collateral!$A:$C,3,FALSE),\"\")","v":18360294.21000002},null,null,6.2176957962033423E-2,21338088.419999991,null,null,6.6011998063524785E-2,24269876.16]
["Backhoes","Backhoes",null,null,8.8189799127324695E-4,{"$f":"IFERROR(VLOOKUP($A78,[9]Collateral!$A:$C,3,FALSE),\"\")","v":244697.99},null,null,8.2326065637913684E-4,282529.24,null,null,8.6852040077186568E-4,319318.95999999996]
["BALERS, WINDROWERS, MOWERS, RAKES","BALERS, WINDROWERS, MOWERS, RAKES",null,null,3.7631061889959468E-2,{"$f":"IFERROR(VLOOKUP($A79,[9]Collateral!$A:$C,3,FALSE),\"\")","v":10441394.919999998},null,null,3.604383276489264E-2,12369638.460000001,null,null,3.9300310659156019E-2,14449095.630000001]
["Cane Harvesters","Cane Harvesters",null,null,0,{"$f":"IFERROR(VLOOKUP($A80,[9]Collateral!$A:$C,3,FALSE),\"\")","v":""},null,null,0,"",null,null,0,""]
["Combines","Combines",null,null,0.36142516276423314,{"$f":"IFERROR(VLOOKUP($A81,[9]Collateral!$A:$C,3,FALSE),\"\")","v":100283719.59000015},null,null,0.3811649832366002,130809424.9300002,null,null,0.37264571209175645,137006385.9500002]
["COMMERCIAL VEHICLE","COMMERCIAL VEHICLE",null,null,0,{"$f":"IFERROR(VLOOKUP($A82,[9]Collateral!$A:$C,3,FALSE),\"\")","v":""},null,null,0,"",null,null,0,""]
["Cotton Pickers","Cotton Pickers",null,null,8.4885415178846788E-4,{"$f":"IFERROR(VLOOKUP($A83,[9]Collateral!$A:$C,3,FALSE),\"\")","v":235529.39999999988},null,null,7.2966895823027534E-4,250410.13999999984,null,null,7.1059588521620812E-4,261256.65999999986]
["CRAWLERS / DOZERS","CRAWLERS / DOZERS",null,null,1.8257775583133339E-3,{"$f":"IFERROR(VLOOKUP($A84,[9]Collateral!$A:$C,3,FALSE),\"\")","v":506593.85000000003},null,null,1.5863428745000146E-3,544406.25,null,null,1.5803517257390951E-3,581029.84000000008]
["CULTIVATORS,SEEDERS, HARROWS","CULTIVATORS,SEEDERS, HARROWS",null,null,2.0448769128670642E-2,{"$f":"IFERROR(VLOOKUP($A85,[9]Collateral!$A:$C,3,FALSE),\"\")","v":5673867.9000000013},null,null,2.1695560516878008E-2,7445552.2399999974,null,null,2.1460230402348207E-2,7890037.4099999974]
["Drill","Drill",null,null,5.275140852922523E-4,{"$f":"IFERROR(VLOOKUP($A86,[9]Collateral!$A:$C,3,FALSE),\"\")","v":146367.99},null,null,5.0815800907832043E-4,174391.3,null,null,5.2727424577352837E-4,193856.88999999998]
["DUMP TRUCKS","DUMP TRUCKS",null,null,7.9577185400070568E-4,{"$f":"IFERROR(VLOOKUP($A87,[9]Collateral!$A:$C,3,FALSE),\"\")","v":220800.79000000012},null,null,6.8744518589203838E-4,235919.65000000011,null,null,6.8179720854193756E-4,250668.58000000013]
["EXCAVATORS / GRADERS","EXCAVATORS / GRADERS",null,null,1.1721843796271249E-2,{"$f":"IFERROR(VLOOKUP($A88,[9]Collateral!$A:$C,3,FALSE),\"\")","v":3252430.149999999},null,null,1.0642943522145886E-2,3652479.5899999994,null,null,1.2932368141216314E-2,4754695.8499999996]
["FEEDERS, MIXERS, WAGONS, BINS, FEED STORAGE","FEEDERS, MIXERS, WAGONS, BINS, FEED STORAGE",null,null,2.1189404822376302E-3,{"$f":"IFERROR(VLOOKUP($A89,[9]Collateral!$A:$C,3,FALSE),\"\")","v":587937.02},null,null,1.936488669090506E-3,664570.41,null,null,2.2214069208371019E-3,816719.27]
["Front End Loader","Front End Loader",null,null,4.43982846954993E-4,{"$f":"IFERROR(VLOOKUP($A90,[9]Collateral!$A:$C,3,FALSE),\"\")","v":123190.79000000001},null,null,3.9859912565355285E-4,136792.53000000003,null,null,3.8570743449030788E-4,141808.64000000001]
["Fronts","Fronts",null,null,6.1871412215763538E-3,{"$f":"IFERROR(VLOOKUP($A91,[9]Collateral!$A:$C,3,FALSE),\"\")","v":1716730.32},null,null,6.85273774341685E-3,2351744.58,null,null,6.8944005520632581E-3,2534785.3799999994]
["GUIDANCE SYSTEMS","Guidance Systems",null,null,1.1161109382326361E-3,{"$f":"IFERROR(VLOOKUP($A92,[9]Collateral!$A:$C,3,FALSE),\"\")","v":309684.46000000002},null,null,1.3860733487377484E-3,475677.1100000001,null,null,1.4580108234005986E-3,536050.16]
["HARVESTERS - Other","HARVESTERS - Other",null,null,7.3470106974001803E-3,{"$f":"IFERROR(VLOOKUP($A93,[9]Collateral!$A:$C,3,FALSE),\"\")","v":2038556.35},null,null,7.5036320742547929E-3,2575120.59,null,null,7.3747272985226755E-3,2711381.6199999996]
["Irrigation Equipment","Irrigation Equipment",null,null,1.1088502308104009E-3,{"$f":"IFERROR(VLOOKUP($A94,[9]Collateral!$A:$C,3,FALSE),\"\")","v":307669.84999999998},null,null,1.0167561911976777E-3,348933.66,null,null,1.0129081990045133E-3,372404.37]
["Other AG","Other AG",null,null,6.6101347599698953E-3,{"$f":"IFERROR(VLOOKUP($A95,[9]Collateral!$A:$C,3,FALSE),\"\")","v":1834097.2599999995},null,null,6.5454228021348693E-3,2246279.2499999995,null,null,6.5390135594409577E-3,2404124.3099999996]
["MATERIALS HANDLING EQUIPMENT","MATERIALS HANDLING EQUIPMENT",null,null,1.4072215493809649E-3,{"$f":"IFERROR(VLOOKUP($A96,[9]Collateral!$A:$C,3,FALSE),\"\")","v":390458.18},null,null,1.2224820152591097E-3,419535.31,null,null,1.2439409266735096E-3,457345.52999999997]
["Other CE","Other CE",null,null,2.8826500533160907E-3,{"$f":"IFERROR(VLOOKUP($A97,[9]Collateral!$A:$C,3,FALSE),\"\")","v":799841.57000000007},null,null,2.5683867912321252E-3,881427.24,null,null,2.7089929841990915E-3,995984.46]
["Over 100 HP Tractor","Over 100 HP Tractor",null,null,0,{"$f":"IFERROR(VLOOKUP($A98,[9]Collateral!$A:$C,3,FALSE),\"\")","v":""},null,null,0,"",null,null,0,""]
["OVER 140 HP TRACTOR","OVER 140 HP TRACTOR",null,null,0.19634142645301494,{"$f":"IFERROR(VLOOKUP($A99,[9]Collateral!$A:$C,3,FALSE),\"\")","v":54478355.640000023},null,null,0.19239123122244869,66025441.539999962,null,null,0.18879115664699647,69410684.819999933]
["Rollers","Rollers",null,null,3.9401486037272466E-5,{"$f":"IFERROR(VLOOKUP($A100,[9]Collateral!$A:$C,3,FALSE),\"\")","v":10932.63},null,null,3.6113450213700086E-5,12393.529999999999,null,null,3.7566512784961905E-5,13811.65]
["SCRAPERS","SCRAPERS",null,null,1.2136339797497262E-3,{"$f":"IFERROR(VLOOKUP($A101,[9]Collateral!$A:$C,3,FALSE),\"\")","v":336743.92999999982},null,null,1.0749185634978235E-3,368894.00999999989,null,null,1.0764334437073871E-3,395759.9699999998]
["SKIDSTEER / UNILOADER","SKIDSTEER / UNILOADER",null,null,1.7598183628813359E-3,{"$f":"IFERROR(VLOOKUP($A102,[9]Collateral!$A:$C,3,FALSE),\"\")","v":488292.32},null,null,1.6914464409777752E-3,580476.03000000014,null,null,1.8350795361410561E-3,674682.7]
["SPRAYING EQUIPMENT","SPRAYING EQUIPMENT",null,null,3.284558848531785E-2,{"$f":"IFERROR(VLOOKUP($A103,[9]Collateral!$A:$C,3,FALSE),\"\")","v":9113581.8000000007},null,null,3.3518699604054458E-2,11503055.140000002,null,null,3.3795823318430528E-2,12425323.740000008]
["Trenchers","Trenchers",null,null,0,{"$f":"IFERROR(VLOOKUP($A104,[9]Collateral!$A:$C,3,FALSE),\"\")","v":""},null,null,9.394110334779354E-5,32239.010000000009,null,null,1.0514432190910992E-4,38657.210000000021]
["TRUCK - on Farm","TRUCK - on Farm",null,null,1.4314839265063814E-4,{"$f":"IFERROR(VLOOKUP($A105,[9]Collateral!$A:$C,3,FALSE),\"\")","v":39719.020000000004},null,null,1.1573707017346618E-4,{"$f":"VLOOKUP(A105,[1]Collateral!$A$2:$C$33,3,0)","v":39719.020000000004}]
["Under 40 HP Tractors","Under 40 HP Tractors",null,null,3.5439009769817655E-3,{"$f":"IFERROR(VLOOKUP($A106,[9]Collateral!$A:$C,3,FALSE),\"\")","v":983317.18000000052},null,null,3.3548047950705444E-3,1151312.7000000004,null,null,3.6676840041111065E-3,1348455.4199999997]
["Wheel Loaders","Wheel Loaders",null,null,3.2527386120157799E-4,{"$f":"IFERROR(VLOOKUP($A107,[9]Collateral!$A:$C,3,FALSE),\"\")","v":90252.909999999974},null,null,4.0885376466770425E-4,140311.74999999997,null,null,4.807681070520768E-4,176758.50999999998]
[null,"Total",null,null,{"$f":"SUM(E72:E107)","v":1},{"$f":"SUM(F72:F107)","v":277467453.63000023},{"$f":"E13-F108","v":0},null,{"$f":"SUM(I72:I107)","v":1.0000000000000002},{"$f":"SUM(J72:J107)","v":343183216.41000003},null,null,0.99999999999999989,367658560.1400001]
["$ 0 - $25,000"]
["$ 25,001 to $50,000","Contract Balance Distribution"]
["$0 - $25,000","$ 0 - $25,000",null,null,{"$f":"IFERROR(F111/F$122,0)","v":7.1560568600875993E-2},{"$f":"IFERROR(VLOOKUP($A111,'[9]Balance Distribution'!$A:$C,3,FALSE),\"\")","v":19855728.749999993},null,null,5.4787290493650498E-2,18802078.569999997,null,null,5.1203005197734706E-2,18820816.689999975]
["$25,001 - $50,000","$ 25,001 to $50,000",null,null,{"$f":"IFERROR(F112/F$122,0)","v":0.12742604729831705},{"$f":"IFERROR(VLOOKUP($A112,'[9]Balance Distribution'!$A:$C,3,FALSE),\"\")","v":35356580.869999975},null,null,0.10649840100669625,36548463.800000004,null,null,0.10891893011095263,40035603.570000038]
["$50,001 - $75,000","$ 50,001 to $75,000",null,null,0.1150435735160712,{"$f":"IFERROR(VLOOKUP($A113,'[9]Balance Distribution'!$A:$C,3,FALSE),\"\")","v":31920847.39999998},null,null,9.9457484946532004E-2,34132139.580000013,null,null,0.10035965214635163,36889448.360000014]
["$75,001 - $100,000","$ 75,001 to $100,000",null,null,0.11393798100067286,{"$f":"IFERROR(VLOOKUP($A114,'[9]Balance Distribution'!$A:$C,3,FALSE),\"\")","v":31614081.460000016},null,null,9.1573594853353243E-2,31426520.819999993,null,null,8.6953044895324877E-2,31961548.199999984]
["$100,001 - $125,000","$100,001 to $125,000",null,null,0.10969415396944837,{"$f":"IFERROR(VLOOKUP($A115,'[9]Balance Distribution'!$A:$C,3,FALSE),\"\")","v":30436557.579999994},null,null,9.0804248313735347E-2,31162494.000000019,null,null,9.1619316676684562E-2,33676741.390000008]
["$125,001 - $150,000","$125,001 to $150,000",null,null,9.4030394875758122E-2,{"$f":"IFERROR(VLOOKUP($A116,'[9]Balance Distribution'!$A:$C,3,FALSE),\"\")","v":26090374.230000004},null,null,8.9654056488711956E-2,30767767.470000003,null,null,9.1784657173593145E-2,33737516.009999998]
["$150,001 - $200,000","$150,000 to $200,000",null,null,0.17161191630603428,{"$f":"IFERROR(VLOOKUP($A117,'[9]Balance Distribution'!$A:$C,3,FALSE),\"\")","v":47616721.430000007},null,null,0.1672794451329328,57407498.020000003,null,null,0.16863151189481226,61984306.610000007]
["$200,001 - $300,000","$200,001 to $300,000",null,null,0.15220009744391158,{"$f":"IFERROR(VLOOKUP($A118,'[9]Balance Distribution'!$A:$C,3,FALSE),\"\")","v":42230573.480000019},null,null,0.23213452068945239,79664671.449999973,null,null,0.2317617934409352,85189262.09999992]
["$300,001 - $400,000","$300,001 to $400,000",null,null,1.0889471577553397E-2,{"$f":"IFERROR(VLOOKUP($A119,'[9]Balance Distribution'!$A:$C,3,FALSE),\"\")","v":3021473.95},null,null,2.9833169224011229E-2,10238242.969999999,null,null,2.8671342946786482E-2,10538797.239999998]
["$400,001 - $500,000","$400,001 to $500,000",null,null,7.8157833707294538E-3,{"$f":"IFERROR(VLOOKUP($A120,'[9]Balance Distribution'!$A:$C,3,FALSE),\"\")","v":2168625.5099999998},null,null,6.3606991997887012E-3,2182885.21,null,null,4.6820749493900913E-3,1721002]
["$500,001+","$500,000+",null,null,2.5790012040627676E-2,{"$f":"IFERROR(VLOOKUP($A121,'[9]Balance Distribution'!$A:$C,3,FALSE),\"\")","v":7155888.9700000016},null,null,3.161708965113548E-2,10850454.52,null,null,3.5414670567434317E-2,13017459.040000001]
["$200,001 to $300,000","Total",null,null,{"$f":"SUM(E111:E121)","v":1},{"$f":"SUM(F111:F121)","v":277467453.63},null,null,0.99999999999999989,343183216.41000003,null,null,1,367572501.20999998]
["0"]
["0 to 5","Residual / Balloon Payment Distribution"]
["0","0",null,null,{"$f":"IFERROR(F125/F$135,0)","v":0.89454393411841837},{"$f":"IFERROR(VLOOKUP($A125,[9]Residual!$A:$C,3,FALSE),\"\")","v":248206827.55999991},null,null,0.89977427964044865,308787431.32999998,null,null,0.89658671487973141,329560621.34000003]
["0 to 5","0 to 5",null,null,{"$f":"IFERROR(F126/F$135,0)","v":0},{"$f":"IFERROR(VLOOKUP($A126,[9]Residual!$A:$C,3,FALSE),\"\")","v":""},null,null,0,"",null,null,0,""]
["6 to 10","06 to 10",null,null,1.8353699265899741E-3,{"$f":"IFERROR(VLOOKUP($A127,[9]Residual!$A:$C,3,FALSE),\"\")","v":509255.41999999993},null,null,1.5719135558060486E-3,539454.34999999986,null,null,1.5629147667708355E-3,574484.48999999987]
["11 to 15","11 to 15",null,null,7.086374110824396E-3,{"$f":"IFERROR(VLOOKUP($A128,[9]Residual!$A:$C,3,FALSE),\"\")","v":1966238.1799999997},null,null,6.4865455638731364E-3,2226073.5700000003,null,null,6.292321004390403E-3,2312884.17]
["16 to 20","16 to 20",null,null,1.2327132408693387E-2,{"$f":"IFERROR(VLOOKUP($A129,[9]Residual!$A:$C,3,FALSE),\"\")","v":3420378.040000001},null,null,1.1437198039751306E-2,3925054.41,null,null,1.0981686270632758E-2,4036565.89]
["21 to 25","21 to 25",null,null,1.6884179563081827E-2,{"$f":"IFERROR(VLOOKUP($A130,[9]Residual!$A:$C,3,FALSE),\"\")","v":4684810.3099999987},null,null,1.5499904877763718E-2,5319307.2100000009,null,null,1.5467362823074335E-2,5685377.2400000002]
["26 to 30","26 to 30",null,null,4.1114043145442918E-2,{"$f":"IFERROR(VLOOKUP($A131,[9]Residual!$A:$C,3,FALSE),\"\")","v":11407808.859999998},null,null,3.9348392154082368E-2,13503707.779999997,null,null,3.9776527737712696E-2,14620757.789999999]
["31 to 35","31 to 35",null,null,9.8076438674095066E-3,{"$f":"IFERROR(VLOOKUP($A132,[9]Residual!$A:$C,3,FALSE),\"\")","v":2721301.9699999997},null,null,8.6910341688641191E-3,2982617.0599999996,null,null,9.1264798616788757E-3,3354643.0299999993]
["36 to 40","36 to 40",null,null,9.8816301664562227E-3,{"$f":"IFERROR(VLOOKUP($A133,[9]Residual!$A:$C,3,FALSE),\"\")","v":2741830.76},null,null,8.9963138124782623E-3,3087383.9099999997,null,null,8.7230507707870102E-3,3206353.5900000003]
["41+ %","41+%",null,null,6.5196926930835182E-3,{"$f":"IFERROR(VLOOKUP($A134,[9]Residual!$A:$C,3,FALSE),\"\")","v":1809002.53},null,null,8.1944181869322182E-3,2812186.7899999996,null,null,1.1482941885221663E-2,4220813.67]
[null,null,null,null,{"$f":"SUM(E125:E134)","v":1.0000000000000002},{"$f":"SUM(F125:F134)","v":277467453.62999988},null,null,0.99999999999999989,343183216.41000003,null,null,1,367572501.21000004]
["2004 Q1"]
["2004 Q2","Quarter of Maturity Distribution"]
[{"$f":"RIGHT(B138,2)&LEFT(B138,4)","v":"Q12013"},"2013Q1",null,null,{"$f":"F138/F$167","v":0},{"$f":"IFERROR(VLOOKUP($A138,'[9]Maturity Quarter'!$A:$C,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0]
["Q22013","2013Q2",null,null,0,{"$f":"IFERROR(VLOOKUP($A139,'[9]Maturity Quarter'!$A:$C,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0]
[{"$f":"RIGHT(B140,2)&LEFT(B140,4)","v":"Q32013"},"2013Q3",null,null,0,{"$f":"IFERROR(VLOOKUP($A140,'[9]Maturity Quarter'!$A:$C,3,FALSE),0)","v":0},null,null,0,0,null,null,1.9384382064884884E-3,712516.58000000007]
[{"$f":"RIGHT(B141,2)&LEFT(B141,4)","v":"Q42013"},"2013Q4",null,null,1.1793977842041867E-4,{"$f":"IFERROR(VLOOKUP($A141,'[9]Maturity Quarter'!$A:$C,3,FALSE),0)","v":32724.449999999983},null,null,9.9281839468788103E-4,340718.60999999987,null,null,7.7275357668206458E-3,2840429.65]
["Q12014","2014Q1",null,null,3.3693937713021867E-3,{"$f":"IFERROR(VLOOKUP($A142,'[9]Maturity Quarter'!$A:$C,3,FALSE),0)","v":934897.1100000001},null,null,1.2478739621356413E-2,4282494,null,null,1.4209148869425576E-2,5222892.3900000025]
["Q22014","2014Q2",null,null,7.4932625170968962E-3,{"$f":"IFERROR(VLOOKUP($A143,'[9]Maturity Quarter'!$A:$C,3,FALSE),0)","v":2079136.4699999997},null,null,7.4069642932746019E-3,2541945.8300000005,null,null,7.893864286497014E-3,2901567.4399999995]
["Q32014","2014Q3",null,null,6.7950393652805334E-3,{"$f":"IFERROR(VLOOKUP($A144,'[9]Maturity Quarter'!$A:$C,3,FALSE),0)","v":1885402.2700000005},null,null,6.8147145261496928E-3,2338695.6500000008,null,null,7.3839647717536053E-3,2714142.3999999994]
["Q42014","2014Q4",null,null,9.8287954652752051E-3,{"$f":"IFERROR(VLOOKUP($A145,'[9]Maturity Quarter'!$A:$C,3,FALSE),0)","v":2727170.8500000015},null,null,9.7498932640183184E-3,3345999.73,null,null,1.5131253621234401E-2,5561832.7399999984]
["Q12015","2015Q1",null,null,3.7981817910987418E-2,{"$f":"IFERROR(VLOOKUP($A146,'[9]Maturity Quarter'!$A:$C,3,FALSE),0)","v":10538718.300000003},null,null,5.6435032874281442E-2,19367556.099999994,null,null,5.5697331880394267E-2,20472807.589999992]
["Q22015","2015Q2",null,null,4.0281753242685708E-2,{"$f":"IFERROR(VLOOKUP($A147,'[9]Maturity Quarter'!$A:$C,3,FALSE),0)","v":11176875.499999996},null,null,3.6969209603894583E-2,12687212.260000007,null,null,3.8414431448268144E-2,14120088.650000002]
["Q32015","2015Q3",null,null,4.0320626018064909E-2,{"$f":"IFERROR(VLOOKUP($A148,'[9]Maturity Quarter'!$A:$C,3,FALSE),0)","v":11187661.429999994},null,null,3.8821006573011935E-2,13322717.899999989,null,null,3.935613399364498E-2,14466232.609999992]
["Q42015","2015Q4",null,null,5.6157011880673027E-2,{"$f":"IFERROR(VLOOKUP($A149,'[9]Maturity Quarter'!$A:$C,3,FALSE),0)","v":15581743.089999998},null,null,5.2590080828539311E-2,18048033.09,null,null,5.8858733525443067E-2,21634851.899999987]
["Q12016","2016Q1",null,null,0.14401699848835708,{"$f":"IFERROR(VLOOKUP($A150,'[9]Maturity Quarter'!$A:$C,3,FALSE),0)","v":39960029.849999987},null,null,0.16541271876239069,56766868.859999999,null,null,0.15973500405150182,58714194.969999999]
["Q22016","2016Q2",null,null,6.6239645441474648E-2,{"$f":"IFERROR(VLOOKUP($A151,'[9]Maturity Quarter'!$A:$C,3,FALSE),0)","v":18379345.750000004},null,null,5.6859602559023614E-2,19513261.289999992,null,null,5.6388046281401517E-2,20726695.209999993]
["Q32016","2016Q3",null,null,6.0720693867276611E-2,{"$f":"IFERROR(VLOOKUP($A152,'[9]Maturity Quarter'!$A:$C,3,FALSE),0)","v":16848016.309999995},null,null,5.47244416450803E-2,18780509.90000001,null,null,5.4185146207716771E-2,19916969.719999999]
["Q42016","2016Q4",null,null,5.9267406014144423E-2,{"$f":"IFERROR(VLOOKUP($A153,'[9]Maturity Quarter'!$A:$C,3,FALSE),0)","v":16444776.229999997},null,null,5.4548757907889683E-2,18720218.190000005,null,null,5.5692637486786704E-2,20471082.059999995]
["Q12017","2017Q1",null,null,0.20869424284700738,{"$f":"IFERROR(VLOOKUP($A154,'[9]Maturity Quarter'!$A:$C,3,FALSE),0)","v":57905860.149999969},null,null,0.21682074067719995,74409239.170000002,null,null,0.20816143046099669,76514417.650000036]
["Q22017","2017Q2",null,null,0.11767035449692069,{"$f":"IFERROR(VLOOKUP($A155,'[9]Maturity Quarter'!$A:$C,3,FALSE),0)","v":32649693.629999995},null,null,0.10032623500697725,34430280.019999996,null,null,9.456932402606591E-2,34761082.969999991]
["Q32017","2017Q3",null,null,4.1999293205536609E-2,{"$f":"IFERROR(VLOOKUP($A156,'[9]Maturity Quarter'!$A:$C,3,FALSE),0)","v":11653436.939999999},null,null,3.7589496668707451E-2,12900084.370000005,null,null,3.5962150831429993E-2,13218697.730000002]
["Q42017","2017Q4",null,null,3.9101593603362197E-2,{"$f":"IFERROR(VLOOKUP($A157,'[9]Maturity Quarter'!$A:$C,3,FALSE),0)","v":10849419.610000003},null,null,3.4297506192546491E-2,11770328.489999998,null,null,3.4994581742803302E-2,12863045.940000009]
["Q12018","2018Q1",null,null,4.8222672839468912E-2,{"$f":"IFERROR(VLOOKUP($A158,'[9]Maturity Quarter'!$A:$C,3,FALSE),0)","v":13380222.239999998},null,null,4.6867017414932446E-2,16083973.780000001,null,null,4.4013859352218229E-2,16178284.370000003]
["Q22018","2018Q2",null,null,1.0073970418625637E-2,{"$f":"IFERROR(VLOOKUP($A159,'[9]Maturity Quarter'!$A:$C,3,FALSE),0)","v":2795198.92},null,null,8.8009969473320359E-3,3020354.44,null,null,8.2920890435671125E-3,3047943.91]
["Q32018","2018Q3",null,null,1.5742990908854152E-3,{"$f":"IFERROR(VLOOKUP($A160,'[9]Maturity Quarter'!$A:$C,3,FALSE),0)","v":436816.76},null,null,1.4223299003551639E-3,488119.75,null,null,1.3279550249084859E-3,488119.75]
["Q42018","2018Q4",null,null,7.3189737154110343E-5,{"$f":"IFERROR(VLOOKUP($A161,'[9]Maturity Quarter'!$A:$C,3,FALSE),0)","v":20307.769999999993},null,null,7.169633835066251E-5,24604.979999999996,null,null,6.6939120633354398E-5,24604.979999999996]
["Q12019","2019Q1",null,null,0,{"$f":"IFERROR(VLOOKUP($A162,'[9]Maturity Quarter'!$A:$C,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0]
["Q22019","2019Q2",null,null,0,{"$f":"IFERROR(VLOOKUP($A163,'[9]Maturity Quarter'!$A:$C,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0]
["Q32019","2019Q3",null,null,0,{"$f":"IFERROR(VLOOKUP($A164,'[9]Maturity Quarter'!$A:$C,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0]
["Q42019","2019Q4",null,null,0,{"$f":"IFERROR(VLOOKUP($A165,'[9]Maturity Quarter'!$A:$C,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0]
[]
[null,null,null,null,{"$f":"SUM(E138:E165)","v":1},{"$f":"SUM(F138:F166)","v":277467453.62999994},null,null,0.99999999999999989,343183216.41000003,null,null,1,367572501.20999998]
["0 to 6 months"]
["07 to 12 months","Seasoning Distribution"]
["0 to 6 months","0 to 6 months",null,null,{"$f":"F170/F$181","v":0},{"$f":"IFERROR(VLOOKUP($A170,[9]Seasoning!$A:$C,3,FALSE),0)","v":0},null,null,0,0,null,null,3.2231018917357711E-2,11847236.24]
["07 to 12 months","07 to 12 months",null,null,3.7505071689874249E-2,{"$f":"IFERROR(VLOOKUP($A171,[9]Seasoning!$A:$C,3,FALSE),0)","v":10406436.74},null,null,0.11850686226861448,40669566.159999982,null,null,0.30516409905733294,112169931.17000008]
["13 to 18 months","13 to 18 months",null,null,0.31275183357439151,{"$f":"IFERROR(VLOOKUP($A172,[9]Seasoning!$A:$C,3,FALSE),0)","v":86778454.879999876},null,null,0.34434390695499212,118173049.53999995,null,null,0.23779916566735287,87408434.110000059]
["19 to 24 months","19 to 24 months",null,null,0.25401195011500133,{"$f":"IFERROR(VLOOKUP($A173,[9]Seasoning!$A:$C,3,FALSE),0)","v":70480048.98999995},null,null,0.20200326480179243,69324130.14000006,null,null,0.1990352718692702,73159892.710000008]
["25 to 30 months","25 to 30 months",null,null,0.19152550032359639,{"$f":"IFERROR(VLOOKUP($A174,[9]Seasoning!$A:$C,3,FALSE),0)","v":53142092.879999988},null,null,0.24757288835038813,84962860.120000005,null,null,0.15768501889885947,57960676.7999999]
["31 to 36 months","31 to 36 months",null,null,0.15266784487987956,{"$f":"IFERROR(VLOOKUP($A175,[9]Seasoning!$A:$C,3,FALSE),0)","v":42360358.169999979},null,null,3.5859372607830738E-2,12306334.83,null,null,2.6704697407143652E-2,9815912.4199999943]
["37 to 42 months","37 to 42 months",null,null,2.2682744075608323E-2,{"$f":"IFERROR(VLOOKUP($A176,[9]Seasoning!$A:$C,3,FALSE),0)","v":6293723.2400000039},null,null,3.1570164425104713E-2,10834350.569999993,null,null,2.5765002465702271E-2,9470506.4000000022]
["43 to 48 months","43 to 48 months",null,null,2.3287568705684703E-2,{"$f":"IFERROR(VLOOKUP($A177,[9]Seasoning!$A:$C,3,FALSE),0)","v":6461542.3900000034},null,null,1.3709629652689808E-2,4704914.7999999989,null,null,5.8951198549045559E-3,2166883.9500000002]
["49 to 54 months","49 to 54 months",null,null,3.6714866074291034E-3,{"$f":"IFERROR(VLOOKUP($A178,[9]Seasoning!$A:$C,3,FALSE),0)","v":1018718.0399999999},null,null,2.3794840509461616E-3,816598.99,null,null,1.3750557735852991E-3,505432.68999999989]
["55 to 60 months","55 to 60 months",null,null,9.2615150583634271E-4,{"$f":"IFERROR(VLOOKUP($A179,[9]Seasoning!$A:$C,3,FALSE),0)","v":256976.89999999988},null,null,3.4859626951300412E-3,1196323.8899999997,null,null,7.3422208438224104E-3,2698798.4800000004]
["60+ months","61 to 72 months",null,null,9.6984852269860883E-4,{"$f":"IFERROR(VLOOKUP($A180,[9]Seasoning!$A:$C,3,FALSE),0)","v":269101.40000000002},null,null,5.6846419251147082E-4,195087.36999999997,null,null,1.0033292446686617E-3,368796.24000000005]
["61 to 72 months","Total",null,null,{"$f":"SUM(E170:E180)","v":1},{"$f":"SUM(F170:F180)","v":277467453.62999976},null,null,1.0000000000000002,343183216.40999997,null,null,0.99999999999999989,367572501.21000004]
[]
[null,"Remaining Term Distribution"]
["0 - 12 months","0-12 Months",null,null,{"$f":"F184/F$190","v":7.2826059509471866E-2},{"$f":"IFERROR(VLOOKUP($A184,'[9]Remaining Term'!$A:$C,3,FALSE),0)","v":20206861.29000001},null,null,4.1201393727563346E-2,14139626.819999993,null,null,4.7161758865585025E-2,15855852.100000001]
["13 - 24 months","13-24 Months",null,null,0.28410552520195387,{"$f":"IFERROR(VLOOKUP($A185,'[9]Remaining Term'!$A:$C,3,FALSE),0)","v":78830036.639999941},null,null,0.18608486757611487,63861203.38000004,null,null,0.16526503309678539,55562345.10999994]
["25 - 36 months","25-36 Months",null,null,0.40278127412027626,{"$f":"IFERROR(VLOOKUP($A186,'[9]Remaining Term'!$A:$C,3,FALSE),0)","v":111758694.50000009},null,null,0.32869572349725495,112802855.61,null,null,0.34975332779205076,117587578.79999998]
["37 - 48 months","37-48 Months",null,null,0.23126875696768889,{"$f":"IFERROR(VLOOKUP($A187,'[9]Remaining Term'!$A:$C,3,FALSE),0)","v":64169553.099999972},null,null,0.38887564615211545,133455595.03000005,null,null,0.43774669501867736,147171077.17000023]
["49 - 60 months","49-60 Months",null,null,9.0183842006089886E-3,{"$f":"IFERROR(VLOOKUP($A188,'[9]Remaining Term'!$A:$C,3,FALSE),0)","v":2502308.0999999996},null,null,5.5142369046951377E-2,18923935.570000004,null,null,0,0]
["60+ Months","60+ Months",null,null,0,{"$f":"IFERROR(VLOOKUP($A189,'[9]Remaining Term'!$A:$C,3,FALSE),0)","v":0},null,null,0,0,null,null,7.3185226901337073E-5,24604.98]
[null,null,null,null,{"$f":"SUM(E184:E189)","v":0.99999999999999978},{"$f":"SUM(F184:F189)","v":277467453.63000005},null,null,1,343183216.41000009,null,null,0.99999999999999989,336201458.16000021]
[]
[null,"Origination LVR Distribution"]
["01. 10% to 20%","10% to 20%",null,null,{"$f":"F193/F$203","v":2.6728051174929415E-3},{"$f":"IFERROR(VLOOKUP($A193,'[9]LVR Band'!$A:$C,3,FALSE),0)","v":741616.42999999993},null,null,2.6726378393290033E-3,917204.45,null,null,2.5752862819822036E-3,946604.41999999993]
["02. 21% to 30%","21% to 30%",null,null,1.759669422890504E-2,{"$f":"IFERROR(VLOOKUP($A194,'[9]LVR Band'!$A:$C,3,FALSE),0)","v":4882509.9400000013},null,null,1.8442957252426905E-2,6329313.3899999997,null,null,1.7560755412201631E-2,6454850.7899999982]
["03. 31% to 40%","31% to 40%",null,null,5.2927992122576456E-2,{"$f":"IFERROR(VLOOKUP($A195,'[9]LVR Band'!$A:$C,3,FALSE),0)","v":14685795.199999997},null,null,5.6498853069887514E-2,19389458.119999994,null,null,5.5745438090575382E-2,20490490.109999999]
["04. 41% to 50%","41% to 50%",null,null,9.7937473979333292E-2,{"$f":"IFERROR(VLOOKUP($A196,'[9]LVR Band'!$A:$C,3,FALSE),0)","v":27174461.520000007},null,null,0.10113022109023138,34706194.550000012,null,null,9.8577596394510289E-2,36234413.670000024]
["05. 51% to 60%","51% to 60%",null,null,0.13069346319931496,{"$f":"IFERROR(VLOOKUP($A197,'[9]LVR Band'!$A:$C,3,FALSE),0)","v":36263182.440000057},null,null,0.13492008016698229,46302307.070000023,null,null,0.13244703569973032,48683888.190000035]
["06. 61% to 70%","61% to 70%",null,null,0.15595195902760628,{"$f":"IFERROR(VLOOKUP($A198,'[9]LVR Band'!$A:$C,3,FALSE),0)","v":43271592.960000031},null,null,0.15746924827884828,54040803.109999999,null,null,0.15745144323768451,57874820.810000032]
["07. 71% to 80%","71% to 80%",null,null,0.16317253201297544,{"$f":"IFERROR(VLOOKUP($A199,'[9]LVR Band'!$A:$C,3,FALSE),0)","v":45275066.959999979},null,null,0.16163017897626891,55468764.689999908,null,null,0.1586728404274145,58323772.829999954]
["08. 81% to 90%","81% to 90%",null,null,0.1647284816004024,{"$f":"IFERROR(VLOOKUP($A200,'[9]LVR Band'!$A:$C,3,FALSE),0)","v":45706792.329999991},null,null,0.16183865930566418,55540311.640000001,null,null,0.16215071212834936,59602142.830000058]
["09. 91% to 100%","91% to 100%",null,null,0.21431859871139317,{"$f":"IFERROR(VLOOKUP($A201,'[9]LVR Band'!$A:$C,3,FALSE),0)","v":59466435.850000098},null,null,0.20539716402036159,70488859.390000001,null,null,0.21481889232755177,78961517.559999883]
["> 100%","> 100%",null,null,0,{"$f":"IFERROR(VLOOKUP($A202,'[9]LVR Band'!$A:$C,3,FALSE),0)","v":0},null,null,0,0,null,null,0,0]
[null,null,null,null,{"$f":"SUM(E193:E202)","v":1},{"$f":"SUM(F193:F202)","v":277467453.63000017},null,null,1.0000000000000002,343183216.40999991,null,null,1,367572501.20999998]
[]
[null,"New v Used"]
["New","New",null,null,{"$f":"F206/F$209","v":0.84661628114138399},{"$f":"IFERROR(VLOOKUP($A206,'[9]New v Used'!$A:$C,3,FALSE),0)","v":234908463.73000011},null,null,0.84408467826679867,289675694.81,null,null,0.84198213618048579,309489479.77000004]
["USed","Used",null,null,{"$f":"F207/F$209","v":0.15338371885861599},{"$f":"IFERROR(VLOOKUP($A207,'[9]New v Used'!$A:$C,3,FALSE),0)","v":42558989.900000006},null,null,0.15591532173320144,53507521.600000046,null,null,0.15801786381951421,58083021.440000005]
["Used"]
[null,null,null,null,{"$f":"SUM(E206:E207)","v":1},{"$f":"SUM(F206:F207)","v":277467453.63000011},null,null,1,343183216.41000003,null,null,1,367572501.21000004]
[]
[null,"Contract Type"]
["Finance Lease","Finance Lease",null,null,{"$f":"F212/F$215","v":1.6547258461968944E-2},{"$f":"IFERROR(VLOOKUP($A212,'[9]Loan Type'!$A:$C,3,FALSE),0)","v":4591325.67},null,null,1.4967015414482051E-2,5136428.49,null,null,1.5626139961755495E-2,5743739.3500000015]
["Goods Mortgage","Goods Mortgage",null,null,{"$f":"F213/F$215","v":0.97088596199548438},{"$f":"IFERROR(VLOOKUP($A213,'[9]Loan Type'!$A:$C,3,FALSE),0)","v":269389255.6400004},null,null,0.97093677839395243,333209206.54000002,null,null,0.96817950414816889,355876161.96000004]
["Hire Purchase","Hire Purchase",null,null,{"$f":"F214/F$215","v":1.2566779542546647E-2},{"$f":"IFERROR(VLOOKUP($A214,'[9]Loan Type'!$A:$C,3,FALSE),0)","v":3486872.3199999994},null,null,1.4096206191565484E-2,4837581.38,null,null,1.6194355890075646E-2,5952599.9000000013]
[null,null,null,null,{"$f":"SUM(E212:E214)","v":1},{"$f":"SUM(F212:F214)","v":277467453.63000041},null,null,1,343183216.41000003,null,null,1,367572501.21000004]
[]
[null,"Contract by Source"]
["Non Hardship Refinance","Non Hardship Refinance",null,null,{"$f":"F218/F$220","v":0.99605599793531363},{"$f":"E19-F219","v":276373121.42000031},null,null,0.99520025050399863,341536022.94000012,null,null,0.99524861325520586,365826022.10000026]
["Refinance - Hardship","Hardship Refinance",null,null,{"$f":"F219/F$220","v":3.9440020646864032E-3},{"$f":"VLOOKUP($A219,[9]Source!$A:$C,3,FALSE)","v":1094332.21},null,null,4.7997494960012911E-3,1647193.4700000002,null,null,4.751386744794076E-3,1746479.1099999999]
[null,null,null,null,{"$f":"SUM(E218:E219)","v":1},{"$f":"SUM(F218:F219)","v":277467453.63000029},null,null,0.99999999999999989,343183216.41000015,null,null,0.99999999999999989,367572501.21000028]
[]
[null,"Payment Frequency Distribution"]
["6 Consecutive","6 Consecutive",null,null,{"$f":"F223/F$229","v":5.8969471863963927E-3},{"$f":"IFERROR(VLOOKUP($A223,'[9]Payment Frequency'!$A:$C,3,FALSE),0)","v":1636210.92},null,null,4.6695804554890358E-3,1602521.6400000001,null,null,5.2767471005451642E-3,1939587.13]
["Annual","Annual",null,null,0.72587420230760957,{"$f":"IFERROR(VLOOKUP($A224,'[9]Payment Frequency'!$A:$C,3,FALSE),0)","v":201406466.5699999},null,null,0.7263450871449334,249269443.23000002,null,null,0.70845478419296803,260408497.01999986]
["Monthly","Monthly",null,null,0.20032037387750223,{"$f":"IFERROR(VLOOKUP($A225,'[9]Payment Frequency'!$A:$C,3,FALSE),0)","v":55582384.050000116},null,null,0.187054222061104,64193869.57000006,null,null,0.19857839862808058,72991958.669999957]
["Quarterly","Quarterly",null,null,1.1536847792853695E-2,{"$f":"IFERROR(VLOOKUP($A226,'[9]Payment Frequency'!$A:$C,3,FALSE),0)","v":3201099.7800000003},null,null,9.6526690747090766E-3,3312634.02,null,null,1.0619423588953203E-2,3903408.0900000008]
["Semi Annual","Semi Annual",null,null,4.7360395599850592E-2,{"$f":"IFERROR(VLOOKUP($A227,'[9]Payment Frequency'!$A:$C,3,FALSE),0)","v":13140968.369999999},null,null,6.4171433616059231E-2,22022558.990000006,null,null,6.7892965517957746E-2,24955587.149999995]
["Structured","Structured",null,null,9.0112332357875618E-3,{"$f":"IFERROR(VLOOKUP($A228,'[9]Payment Frequency'!$A:$C,3,FALSE),0)","v":2500323.94},null,null,8.1070076477053766E-3,2782188.9599999995,null,null,9.1776809714954437E-3,3373463.1500000004]
["0% to 1%",null,null,null,{"$f":"SUM(E223:E228)","v":1},{"$f":"SUM(F223:F228)","v":277467453.63},null,null,1.0000000000000002,343183216.41000003,null,null,1.0000000000000002,367572501.20999974]
["1.01% to 2%"]
["2.01% to 3%","Yield Distribution"]
["0% to 1%",null,null,null,{"$f":"F232/F$246","v":0},{"$f":"IFERROR(VLOOKUP(#REF!,'[2]Contract Yield'!$A:$B,2,FALSE),0)","v":0},null,null,0,0,null,null,6.6313345584233963E-2,24374962.29999999]
["1.01% to 2%",null,null,null,0,{"$f":"IFERROR(VLOOKUP(#REF!,'[2]Contract Yield'!$A:$B,2,FALSE),0)","v":0},null,null,0,0,null,null,5.6093023531758865E-2,20618252.959999997]
["2.01% to 3%",null,null,null,0,{"$f":"IFERROR(VLOOKUP(#REF!,'[2]Contract Yield'!$A:$B,2,FALSE),0)","v":0},null,null,0,0,null,null,0.10576804162993877,38877423.610000007]
["3.01% to 4%",null,null,null,0,{"$f":"IFERROR(VLOOKUP(#REF!,'[2]Contract Yield'!$A:$B,2,FALSE),0)","v":0},null,null,0,0,null,null,4.3598290724268178E-2,16025532.769999998]
[null,"< 4%",null,null,0.27630125323538474,{"$f":"SUM('[9]Contract Yield'!$C$2:$C$5)","v":76664605.170000002},null,null,0.2707840952483484,92928556.75999999,null,null,0.27177270147019983,99896171.640000001]
["05. 4.01% to 5%","4% to 5%",null,null,6.5420967873968255E-2,{"$f":"IFERROR(VLOOKUP($A237,'[9]Contract Yield'!$A:$C,3,FALSE),0)","v":18152189.370000005},null,null,6.5484109785693967E-2,22473047.420000009,null,null,6.5995859619925351E-2,24258263.190000005]
["06. 5.01% to 6%","5% to 6%",null,null,0.17097324702182951,{"$f":"IFERROR(VLOOKUP($A238,'[9]Contract Yield'!$A:$C,3,FALSE),0)","v":47439511.49000001},null,null,0.17033950188916222,58457658.139999956,null,null,0.16593563117267435,60993374.989999965]
["07. 6.01% to 7%","6% to 7%",null,null,0.209360522612729,{"$f":"IFERROR(VLOOKUP($A239,'[9]Contract Yield'!$A:$C,3,FALSE),0)","v":58090731.099999949},null,null,0.21535201363607995,73905196.700000092,null,null,0.21107856432294295,77586675.840000018]
["08. 7.01% to 8%","7% to 8%",null,null,0.12763315490408564,{"$f":"IFERROR(VLOOKUP($A240,'[9]Contract Yield'!$A:$C,3,FALSE),0)","v":35414046.489999987},null,null,0.12820041565621848,43996230.989999972,null,null,0.12789768131523374,47011670.619999953]
["09. 8.01% to 9%","8% to 9%",null,null,9.164784030457758E-2,{"$f":"IFERROR(VLOOKUP($A241,'[9]Contract Yield'!$A:$C,3,FALSE),0)","v":25429292.880000025},null,null,9.352456173630283E-2,32096059.910000015,null,null,9.7266413026838625E-2,35752458.720000006]
["10. 9.01% to 10%","9% to 10%",null,null,2.025715047464682E-2,{"$f":"IFERROR(VLOOKUP($A242,'[9]Contract Yield'!$A:$C,3,FALSE),0)","v":5620699.959999999},null,null,2.0773932608297158E-2,7129265.0099999979,null,null,2.2132329358752027E-2,8135235.6599999992]
["11. 10.01% to 11%","10% to 11%",null,null,1.5222388625198119E-2,{"$f":"IFERROR(VLOOKUP($A243,'[9]Contract Yield'!$A:$C,3,FALSE),0)","v":4223717.4099999983},null,null,1.4260953088547922E-2,4894119.7499999991,null,null,1.6398946303538147E-2,6027801.7100000018]
["12. 11.01% to 12%","11% to 12%",null,null,8.853562022722191E-3,{"$f":"IFERROR(VLOOKUP($A244,'[9]Contract Yield'!$A:$C,3,FALSE),0)","v":2456575.3099999987},null,null,8.3411981796339008E-3,2862559.2199999988,null,null,8.3648046572542458E-3,3074672.1700000004]
["13. > 12%","> 12%",null,null,1.4329912924858091E-2,{"$f":"IFERROR(VLOOKUP($A245,'[9]Contract Yield'!$A:$C,3,FALSE),0)","v":3976084.45},null,null,1.2939218171715372E-2,4440522.5100000007,null,null,1.3157068752640489E-2,4836176.67]
[null,null,null,null,{"$f":"SUM(E232:E245)","v":0.99999999999999989},{"$f":"SUM(F236:F245)","v":277467453.63},null,null,1,343183216.40999997,null,null,0.99999999999999956,367572501.21000004]
[]
[null,"Top 5 Obligor",null,null,{"$f":"F248/E19","v":2.1107327159925957E-2},{"$f":"SUM('[9]Top 5 Obligors'!$E$2:$E$6)","v":5856596.3200000012},null,null,2.141126677716482E-2,7347987.4000000004,null,null,2.0885386678080316E-2,7676893.8200000003]

{"sheet":"Note Balances","index":1,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[null,null,"TOTAL NOTE BALANCES"]
[null,null,null,"Total Notes","Class A1 Notes","Class A2 Notes","Class B Notes","Class C Notes","Seller Notes"]
[null,null,"Initial Invested Amount",400000000,100000000,244800000,13600000,12000000,29600000]
["(a)",null,"Invested Amount as at Previous Payment Date:  16 October 2013",367899561.02999997,67899561.030000001,244800000,13600000,12000000,29600000]
["(b)",null,"Stated Amount as at Previous Payment Date:  16 October 2013",367572501.20999998,67899561.030000001,244800000,13600000,12000000,29272940.18]
["(d)",null,"Principal Payments to Noteholders on Payment Date",24290790.890000001,24290790.890000001,0,0,0,0]
[null,null,"Gross Aggregate Charge-Offs",0,0,0,0,0,0]
[null,null,"Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0,0]
["(e)",null,"Aggregate Charge-Offs for this Collection Period",98493.91,0,0,0,0,98493.91]
["(f)",null,"Reinstatements relating to Charge-offs that have occurred this Collection Period",0,0,0,0,0,0]
[null,null,"Aggregate Carry Over Charge-offs not previously reinstated",0,0,0,0,0,0]
[null,null,"Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0,0]
[null,null,"Aggregate Charge-Offs not reinstated and to be carried over to next period",98493.91,0,0,0,0,98493.91]
[null,null,"Invested Amount as at Payment Date:  16 January 2014",343608770.13999999,43608770.140000001,244800000,13600000,12000000,29600000]
[null,null,"Stated Amount as at Payment Date:  16 January 2014",343183216.40999997,43608770.140000001,244800000,13600000,12000000,29174446.27]
[null,null,"Bond Factor at Payment Date:  16 January 2014",null,0.43608770140000003,1,1,1,0.98562318479729727]
[null,null,"Coupon Margin",null,4.4999999999999997E-3,1.0999999999999999E-2,1.7500000000000002E-2,2.5000000000000001E-2,0.01]
[null,null,"Coupon Rate (3 month BBSW + margin)",null,3.0450000000000001E-2,3.6949999999999997E-2,4.3450000000000003E-2,5.0950000000000002E-2,3.5950000000000003E-2]
[null,null,"Days in Coupon Period",null,92,92,92,92,92]
[null,null,"Coupon Entitlement to be paid out on the current Payment Date: 16 January 2014",null,521133.78,2279926.36,148944.22,154106.29999999999,265252.94]
[]
[]
[null,null,"TOTAL NOTE BALANCES"]
[null,null,null,"Total Notes","Class A1 Notes","Class A2 Notes","Class B Notes","Class C Notes","Seller Notes"]
[null,null,"Initial Invested Amount",400000000,100000000,244800000,13600000,12000000,29600000]
["(a)",null,"Invested Amount as at Previous Payment Date:  16 January 2014",343608770.13999999,43608770.140000001,244800000,13600000,12000000,29600000]
["(b)",null,"Stated Amount as at Previous Payment Date:  16 January 2014",343183216.40999997,43608770.140000001,244800000,13600000,12000000,29174446.27]
["(d)",null,"Principal Payments to Noteholders on Payment Date",64728376.420000002,43608770.140000001,21119606.280000001,0,0,0]
[null,null,"Gross Aggregate Charge-Offs",425553.73,0,0,0,0,425553.73]
[null,null,"Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0,0]
["(e)",null,"Aggregate Charge-Offs for this Collection Period",987386.3600000001,0,0,0,0,987386.3600000001]
["(f)",null,"Reinstatements relating to Charge-offs that have occurred this Collection Period",0,0,0,0,0,0]
[null,null,"Aggregate Carry Over Charge-offs not previously reinstated",425553.73,0,0,0,0,425553.73]
[null,null,"Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0,0]
[null,null,"Aggregate Charge-Offs not reinstated and to be carried over to next period",1412940.09,0,0,0,0,1412940.09]
[null,null,"Invested Amount as at Payment Date:  16 April 2014",278880393.72000003,0,223680393.72,13600000,12000000,29600000]
[null,null,"Stated Amount as at Payment Date:  16 April 2014",277467453.63,0,223680393.72,13600000,12000000,28187059.91]
[null,null,"Bond Factor at Payment Date:  16 April 2014",null,0,0.91372709852941181,1,1,0.95226553749999998]
[null,null,"Coupon Margin",null,4.4999999999999997E-3,1.0999999999999999E-2,1.7500000000000002E-2,2.5000000000000001E-2,0.01]
[null,null,"Coupon Rate (3 month BBSW + margin)",null,3.075E-2,3.7249999999999998E-2,4.3749999999999997E-2,5.1250000000000004E-2,3.6249999999999998E-2]
[null,null,"Days in Coupon Period",null,90,90,90,90,90]
[null,null,"Coupon Entitlement to be paid out on the current Payment Date: 16 April 2014",null,330650.06,2248471.23,146712.32999999999,151643.84,260771.59]

{"sheet":"Cumulative Defaults","index":2,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Cumulative Defaults & Losses"]
[]
["Month","Gross Losses","Recoveries","Net Losses"]
["2013-09-01",{"$f":"'Collateral Tables'!M9/400000000","v":8.1764955000000002E-4},{"$f":"'Collateral Tables'!M23/400000000","v":1.1157090909091038E-6},{"$f":"B4-C4","v":8.1653384090909088E-4}]
["2013-12-01",{"$f":"'Collateral Tables'!I9/400000000","v":2.4623477500000001E-4},{"$f":"'Collateral Tables'!I23/400000000","v":2.3625E-4},{"$f":"B5-C5","v":9.9847750000000115E-6}]
["2014-03-01",{"$f":"'Collateral Tables'!E9/400000000","v":2.4684659000000003E-3},{"$f":"'Collateral Tables'!E23/400000000","v":4.7552124999999997E-5},{"$f":"B6-C6","v":2.4209137750000002E-3}]